﻿CREATE TABLE [dbo].[FoodOrder] (
    [FoodOrderId]  INT           IDENTITY (1, 1) NOT NULL,
    [TableOrderId] INT           NULL,
    [FoodId]       INT           NULL,
    [Quantity]     NCHAR (10)    NULL,
    [Note]         NVARCHAR (50) NULL,
    [IsDeleted]    BIT           NOT NULL,
    [Created]      DATETIME      NULL,
    CONSTRAINT [PK_FoodOrder] PRIMARY KEY CLUSTERED ([FoodOrderId] ASC),
    CONSTRAINT [FK_FoodOrder_Food] FOREIGN KEY ([FoodId]) REFERENCES [dbo].[Food] ([FoodId]),
    CONSTRAINT [FK_FoodOrder_TableOrder] FOREIGN KEY ([TableOrderId]) REFERENCES [dbo].[TableOrder] ([TableOrderId])
);



